package com.ssms.dao;

import com.ssms.commons.ESQueryParam;
import com.ssms.model.ExamScore;
import com.ssms.model.SysUser;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ExamScoreMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(ExamScore record);

    int insertSelective(ExamScore record);

    ExamScore selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(ExamScore record);

    int updateByPrimaryKey(ExamScore record);

    int insertBatch(List<ExamScore> list);

    List<ExamScore> selectPage(@Param("start") int start, @Param("size") int size, @Param("esQueryParam")ESQueryParam esQueryParam);

    int selectPageCount(ESQueryParam esQueryParam);

    int checkConflict(ExamScore record);

    // 查询不及格超过3门的学生
    List<SysUser> selectFlunks();

    List<ExamScore> selectByStuId(Integer stuId);

    int deleteByStuId(Integer stuId);
}